package com.itheima.tlias.mapper;

import com.itheima.tlias.pojo.dto.SelectempDetailDTO;
import com.itheima.tlias.pojo.entity.Expr;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ExprMapper {
    int batchInsertExpr(@Param("list") List<Expr> list);
    int batchDeleteExprByEmpIds(@Param("empIds") List<Integer> empIds);
    @Select("select id,company,job,emp_id,begin,end from expr where emp_id = #{empId}")
    List<Expr> selectExprByEmpId(@Param("empId") Integer empId);

    @Select("select * from emp")
    List<SelectempDetailDTO> selectEmpAll();
}
